﻿--This script can be used to insert new fields to an existing set of marriage documents.

DECLARE @DocumentTypeId as integer

This sytax error is here to remind you to setup the document types first and to change it for each document type in the marriage group.
--Set up all marriage related document types, then run this script for each type after changing the select statement below.
Select  @DocumentTypeId = [Id] from [DocumentType] where  [Code] = 'MarriageKiosk'



DECLARE @DisplayOrder as integer
SET @DisplayOrder = 30


--Common to both parties

--SET @DisplayOrder = @DisplayOrder + 1  AKA MarriageDate
--insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
--      Values (@DocumentTypeId, 'CeremonyDate',  'Ceremony Date', 'Solicitar el estatus Marital de', @DisplayOrder)

SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'ApplyingForMaritalStatusOf',  'Applying For Marital Status Of', 'Solicitar el estatus Marital de', @DisplayOrder)


SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BloodRelated',  'Blood Related?', 'Relacion Sanguinea', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BloodRelatedDescription',  'Blood Related Description', 'Descripcion de la Relacion Sanguinea', @DisplayOrder)

                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'CeremonyType',  'Ceremony Type', 'Tipo de Ceremonia', @DisplayOrder)

--Birth City
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomBirthCity',  '[G] Birth City', 'ciudad de nacimiento', @DisplayOrder)

SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideBirthCity',  '[B]  Birth City', 'ciudad de nacimiento', @DisplayOrder)

--
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianRequired',  '[G] Guardian required on ceremony day?', 'The guardian en ceremonia día?', @DisplayOrder)

insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianRequired',  '[B] Guardian required on ceremony day?', 'The guardian en ceremonia día?', @DisplayOrder)

--Groom Father Guardian
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianFatherFirstName',  '[GF] Guardian First', 'Primer Nombre del Padre', @DisplayOrder)

SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianFatherMiddleName',  '[GF] Guardian Middle', 'Segundo Nombre del Padre', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianFatherLastName',  '[GF] Guardian Last', ', Apellidos del Padre', @DisplayOrder)

                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianFatherCity',  '[GF] Guardian City', 'Ciudad del Padre', @DisplayOrder)


                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianFatherState',  '[GF] Guardian State', 'Estado del Padre', @DisplayOrder)

--Bride Father Guardian
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianFatherFirstName',  '[BF] Guardian First', 'Primer Nombre del Padre', @DisplayOrder)

SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianFatherMiddleName',  '[BF] Guardian Middle', 'Segundo Nombre del Padre', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianFatherLastName',  '[BF] Guardian Last', ', Apellidos del Padre', @DisplayOrder)

                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianFatherCity',  '[BF] Guardian City', 'Ciudad del Padre', @DisplayOrder)


                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianFatherState',  '[BF] Guardian State', 'Estado del Padre', @DisplayOrder)

--Groom Guardian Mother
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianMotherFirstName',  '[GM] Guardian Mother First', 'Primer Nombre del Madre', @DisplayOrder)

SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianMotherMiddleName',  '[GM] Guardian Middle', 'Segundo Nombre del Madre', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianMotherLastName',  '[GM] Guardian Last', ', Apellidos del Madre', @DisplayOrder)

                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianMotherCity',  '[GM] Guardian City', 'Ciudad del Madre', @DisplayOrder)


                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGuardianMotherState',  '[GM] Guardian State', 'Estado del Madre', @DisplayOrder)

         --Bride Guardian Mother
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianMotherFirstName',  '[BM] Guardian First', 'Primer Nombre del Madre', @DisplayOrder)

SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianMotherMiddleName',  '[BM] Guardian Middle', 'Segundo Nombre del Madre', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianMotherLastName',  '[BM] Guardian Last', ', Apellidos del Madre', @DisplayOrder)

                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianMotherCity',  '[BM] Guardian City', 'Ciudad del Madre', @DisplayOrder)


                SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGuardianMotherState',  '[BM] Guardian State', 'Estado del Madre', @DisplayOrder)

         
  --Maritial Status
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomPresentMaritalStatus',  '[G] Marital Status', 'Estado Civil Actual ', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BridePresentMaritalStatus',  '[B] Marital Status', 'Estado Civil Actual ', @DisplayOrder)

--Proof of age
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomProofOfAge',  '[G] Proof of Age', 'Prueba de Edad', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideProofOfAge',  '[B] Proof of Age', 'Prueba de Edad', @DisplayOrder)

--Pevious Married Name
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomPreviousMarriedName',  '[G] Previous Married Name', 'Nombres anteriores ', @DisplayOrder)

          SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BridePreviousMarriedName',  '[B] Previous Married Name', 'Nombres anteriores ', @DisplayOrder)

--Gender
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomGender',  '[G] Gender', 'Genero', @DisplayOrder)

SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideGender',  '[B] Gender', 'Genero', @DisplayOrder)

-- Groom Divorced Widowed Date  == use existing GroomDatePreviousMarriageEnded,
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomDivorcedWidowedDate',  '[G] Divorced/Widowed Date', 'Fecha de Divorciado, Viudo ', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomDivorcedWidowedCity',  '[G] Divorced/Widowed City', 'Cuidad del Divorcio ', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomDivorcedWidowedState',  '[G] Divorced/Widowed State', 'Estado del Divorcio ', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomDivorcedWidowedTypeOfCourt',  '[G] Divorced/Widowed Court', 'Tipo de Corte del Divorcio ', @DisplayOrder)

         -- Bride Divorced Widowed Date === same as brideDatePreviousMarriageEnded
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideDivorcedWidowedDate',  '[B] Divorced/Widowed Date', 'Fecha de Divorciado, Viudo ', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideDivorcedWidowedCity',  '[B] Divorced/Widowed City', 'Cuidad del Divorcio ', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideDivorcedWidowedState',  '[B] Divorced/Widowed State', 'Estado del Divorcio ', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideDivorcedWidowedTypeOfCourt',  '[B] Divorced/Widowed Court', 'Tipo de Corte del Divorcio ', @DisplayOrder)

-- All Legal Names Other Than Birth and Current
SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'GroomAllLegalNamesOtherThanBirthOrCurrent',  '[G] All Legal Names Other Than Birth and Current', 'Todos los nombres legales sin contar el de nacimi', @DisplayOrder)

         SET @DisplayOrder = @DisplayOrder + 1
insert into [DocumentTypeField] ([DocumentTypeId], [FieldName] , [Prompt], [SpanishPrompt],  [DisplayOrder])
      Values (@DocumentTypeId, 'BrideAllLegalNamesOtherThanBirthOrCurrent',  '[B] All Legal Names Other Than Birth and Current', 'Todos los nombres legales sin contar el de nacimi', @DisplayOrder)







